﻿<%@ Page Language="C#" MasterPageFile="~/Master.Master" AutoEventWireup="true"   Title="Créer votre compte" CodeBehind="NewsAlbum.aspx.cs" %>
<asp:Content ID="Content1" runat="server" contentplaceholderid="MainContent">
    <div class="auto-style2">
        <strong style="font-size: xx-large; font-style: italic">Nouveautés.<br />
        <br />
        <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Visible="False" Width="100%">
            <Columns>
                <dx:GridViewDataTextColumn FieldName="Nom" VisibleIndex="0">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Prénom" VisibleIndex="1">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Prix" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
            </Columns>
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MusiqueStoreConnectionString %>" SelectCommand="SELECT DISTINCT Album.Nom, Artiste.Prénom, Album.Prix FROM Album INNER JOIN Piste ON Album.Id = Piste.IdAlbum INNER JOIN Artiste ON Piste.IdArtiste = Artiste.Id WHERE (Album.DateSortie &gt;= GETDATE() - 30)"></asp:SqlDataSource>
        </strong>

    </div>
</asp:Content>

<asp:Content ID="Content2" runat="server" contentplaceholderid="head">
    <style type="text/css">
        .auto-style2 {
            font-size: x-large;
        }
    </style>
</asp:Content>


